| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Functions
I would like to see if anyone would be able to help me out on this formula?
If B3+D3=o then E3 would have nothing but if C3+D3=any number but 0 that number would show up on E3 and vice versa Does this make sense to anyone? |
|
#2
|
|||
|
|||
|
=if(C3+D3< 0, C3+D3,if(B3+D3<0,B3+D3,"")
"Krissy" wrote: I would like to see if anyone would be able to help me out on this formula? If B3+D3=o then E3 would have nothing but if C3+D3=any number but 0 that number would show up on E3 and vice versa Does this make sense to anyone? |
|
#3
|
|||
|
|||
|
In E3: =IF(B3+D3=0,"",B3+D3)
-- HTH RP (remove nothere from the email address if mailing direct) "Krissy" wrote in message ... I would like to see if anyone would be able to help me out on this formula? If B3+D3=o then E3 would have nothing but if C3+D3=any number but 0 that number would show up on E3 and vice versa Does this make sense to anyone? |
|
#4
|
|||
|
|||
|
Sorry sent it too soon
=IF(B3+D3<0,B3+D3,IF(C3+D3<0,C3+D3,"")) -- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... In E3: =IF(B3+D3=0,"",B3+D3) -- HTH RP (remove nothere from the email address if mailing direct) "Krissy" wrote in message ... I would like to see if anyone would be able to help me out on this formula? If B3+D3=o then E3 would have nothing but if C3+D3=any number but 0 that number would show up on E3 and vice versa Does this make sense to anyone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
| PivotTable canned functions | Excel Discussion (Misc queries) | |||
Linear Mode
