• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Excel question

A

aolsuxs

Senior member
Is it possible to use the IF fucntion on text? I am trying to to have one spread sheet read another spreadsheet cell value and replace it if certain conditions are met.


For example, if the value is M then it writes Male in the cell otherwise it writes Female.
 
Tried it out, seems to work, use the following format =IF(Cell=value, "Male", "Female"). You may have to refime the rules a bit.
 
Does it matter if the cell is in another worksheet?

I am getting an #name? error on this part of the formula

'Worksheet1'!B6=M
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top