| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What do I call a blank cell?
My formula is IF(H270,H27,(M25+M26)*0.15). I want the test to include zero
in the true statement, but if I put = it accepts blanks. How can I write this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What do I call a blank cell?
=if(and(h27=0,not(isblank(h27))),h27,(m25+m26)*0. 15)
"Nancy" wrote: My formula is IF(H270,H27,(M25+M26)*0.15). I want the test to include zero in the true statement, but if I put = it accepts blanks. How can I write this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What do I call a blank cell?
AWESOME!!!! Thank you.
"bpeltzer" wrote: =if(and(h27=0,not(isblank(h27))),h27,(m25+m26)*0. 15) "Nancy" wrote: My formula is IF(H270,H27,(M25+M26)*0.15). I want the test to include zero in the true statement, but if I put = it accepts blanks. How can I write this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What do I call a blank cell?
Hi Nancy
The following formula seems to do the trick =IF(OR(AND(H27<"",H27=0),H270),H27,(M25+M26)*0.1 5) hth "Nancy" wrote: My formula is IF(H270,H27,(M25+M26)*0.15). I want the test to include zero in the true statement, but if I put = it accepts blanks. How can I write this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What do I call a blank cell?
If H27 cannot be negative =IF(H27="",(M25+M26)*0.15,H27) or if it can =IF(OR(H27="",H27<0),(M25+M26)*0.15,H27) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=514498 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| Setting Purely BLANK Cell | Excel Worksheet Functions | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
