Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Satisfying several criteria
Hi All I'm trying to write a formula to satisfy this criteria : If A1+B1 0 then put A1+B1 , otherwise leave blank. BUT if C1 has content , put "0.00". Can someone help with a formula to include these parameters? Grateful for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Satisfying several criteria
=IF(C1<"",0,IF(A1+B10,A1+B1,""))
Gord Dibben Microsoft Excel MVP On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes wrote: Hi All I'm trying to write a formula to satisfy this criteria : If A1+B1 0 then put A1+B1 , otherwise leave blank. BUT if C1 has content , put "0.00". Can someone help with a formula to include these parameters? Grateful for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Satisfying several criteria
In article , Gord
writes =IF(C1<"",0,IF(A1+B10,A1+B1,"")) Hi Gord OK Thanks for that. It's working fine , but is prioritising results in the opposite way to what is intended. By which I mean : The formula concerning C1 should only have effect if the A1+B1 part of the formula gives a blank cell. So , If A1+B1 0 then put A1+B1 If A1+B1 < 0 then leave blank. IF A1+B1 is now blank , and C1 has content then insert '0.00' IF A1+B1 is now blank , and C1 has NO content then leave blank. Complicated , but can you turn your formaula to satisfy this? Grateful for your help. Gord Dibben Microsoft Excel MVP On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes wrote: Hi All I'm trying to write a formula to satisfy this criteria : If A1+B1 0 then put A1+B1 , otherwise leave blank. BUT if C1 has content , put "0.00". Can someone help with a formula to include these parameters? Grateful for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Satisfying several criteria
=IF(A1+B10,A1+B1,IF(C1<"",0,""))
David Biddulph On 10/09/2011 18:29, Colin Hayes wrote: In article , Gord writes =IF(C1<"",0,IF(A1+B10,A1+B1,"")) Hi Gord OK Thanks for that. It's working fine , but is prioritising results in the opposite way to what is intended. By which I mean : The formula concerning C1 should only have effect if the A1+B1 part of the formula gives a blank cell. So , If A1+B1 0 then put A1+B1 If A1+B1 < 0 then leave blank. IF A1+B1 is now blank , and C1 has content then insert '0.00' IF A1+B1 is now blank , and C1 has NO content then leave blank. Complicated , but can you turn your formaula to satisfy this? Grateful for your help. Gord Dibben Microsoft Excel MVP On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes wrote: Hi All I'm trying to write a formula to satisfy this criteria : If A1+B1 0 then put A1+B1 , otherwise leave blank. BUT if C1 has content , put "0.00". Can someone help with a formula to include these parameters? Grateful for any help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Satisfying several criteria
In article , David Biddulph
writes =IF(A1+B10,A1+B1,IF(C1<"",0,"")) David Biddulph Hi David OK thanks for this. It works perfectly. I'm grateful for your time and expertise. Best Wishes On 10/09/2011 18:29, Colin Hayes wrote: In article , Gord writes =IF(C1<"",0,IF(A1+B10,A1+B1,"")) Hi Gord OK Thanks for that. It's working fine , but is prioritising results in the opposite way to what is intended. By which I mean : The formula concerning C1 should only have effect if the A1+B1 part of the formula gives a blank cell. So , If A1+B1 0 then put A1+B1 If A1+B1 < 0 then leave blank. IF A1+B1 is now blank , and C1 has content then insert '0.00' IF A1+B1 is now blank , and C1 has NO content then leave blank. Complicated , but can you turn your formaula to satisfy this? Grateful for your help. Gord Dibben Microsoft Excel MVP On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes wrote: Hi All I'm trying to write a formula to satisfy this criteria : If A1+B1 0 then put A1+B1 , otherwise leave blank. BUT if C1 has content , put "0.00". Can someone help with a formula to include these parameters? Grateful for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Satisfying two conditions? | Excel Worksheet Functions | |||
Satisfying two variables entered via popup | Excel Discussion (Misc queries) | |||
how to get value from a table satisfying two conditions | Excel Discussion (Misc queries) | |||
Satisfying Multiple Criteria in an "IF" Function | Excel Worksheet Functions | |||
using sumif formula: but requiring satisfying 2 if statements | Excel Worksheet Functions |