=IF(A1>40%, "Larger", "Smaller")
I am using this formula for a spreadsheet I am working on. It works brilliantly but how can I have it so the cell says "Exact" when the value is exactly 40%?
2007-04-03 06:14:24 · 4 answers · asked by Sharon 2 in Computers & Internet ➔ Software
I can't seem to make any of those formulas work? :-(
2007-04-03 06:37:43 · update #1
Nevermind! :)
2007-04-03 07:04:39 · update #2
=IF(A1>40%, "Larger", IF(A1<40%, "Smaller", "Exact"))
In the else portion, put another if statment.
2007-04-03 06:28:23 · answer #1 · answered by Capt Phil 2 · 4⤊ 0⤋
I'm a little rusty, but you need something like this pseudocode:
=IF(A1>40%, "Larger"),
ELSE(A1<40%, "Smaller"),
ELSE(A1=40%, "Exact")
go to www.mrexcel.com for more info OR look in the Excel Help files.
2007-04-03 13:22:54 · answer #2 · answered by ELfaGeek 7 · 0⤊ 0⤋
not exactly sure, but use the help. It has something to do with your > sign. If you want it to be exact then that sign should include equal to.
2007-04-03 13:22:49 · answer #3 · answered by Anonymous · 0⤊ 0⤋
=IF(B2>0,"-->","<--")
Format the cell so it aligns vertically. Another silly excel trick.
2007-04-06 02:54:02 · answer #4 · answered by unnga 6 · 0⤊ 0⤋