What formula will allow me to do this. I want it to show a cross if it a positive number. I tried conditional formatting it but that only changes cell colour or size of font etc?
2006-08-14 02:53:59 · 7 answers · asked by Navarra 1 in Computers & Internet ➔ Software
Try this formula:
=IF(E8<=0,"x"," ")
Enter it into the cell and reference (I used e8) the cell that contains the number.
2006-08-14 03:01:12 · answer #1 · answered by Mork the Stork 3 · 0⤊ 0⤋
Use the formula...
=IF(A1<=0,"þ","ý")
...in column B.
Set column B to the Windings font so that the special characters will show as a tick and a cross. You can go through the Insert - Symbol.. menu to find the characters in the Windings font.
2006-08-14 03:15:46 · answer #2 · answered by Kane M 2 · 0⤊ 0⤋
There is probably a better way, but :
i) Create a new column next to the results
(assuming the values are in A and your new column is B)
ii) enter the following formula in B1 =IF(A1<=0,"ü","û")
iii) Change the font for col B to Wingdings
iv) Hide Column A
2006-08-14 03:07:59 · answer #3 · answered by dumberthangeorgebush 5 · 1⤊ 0⤋
I don't really know what tick means but whatever the symbol is it should work like this =IF(A2<=0,"-","x")
A2 would the were you would like the formula to look for the condition
question e-mail me
2006-08-14 03:07:25 · answer #4 · answered by PC DOCTOR 3 · 0⤊ 0⤋
Try using an "IF" statement. They are pretty tricky in excel but let me see what I can come up with.
=IF(B8>0,"X","Y")
If B8 is greater than 0, X shows up, if less than 0 Y.
Good luck!
2006-08-14 03:02:19 · answer #5 · answered by Anonymous · 0⤊ 0⤋
do you mean a dash? If so, use this:
=if(a1<=0,"-","+")
If you mean a tick (single quote), use a tick mark ' instead of the dash -.
2006-08-14 03:01:27 · answer #6 · answered by nureal1 2 · 0⤊ 0⤋
To know about excel, visit,
http://softwareeng.21publish.com/
2006-08-14 03:03:24 · answer #7 · answered by Anonymous · 0⤊ 1⤋