Recording an outcome when no data in the field, how to stop?
Closed
Joshte
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
-
Mar 9, 2013 at 02:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 10, 2013 at 10:46 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 10, 2013 at 10:46 AM
Related:
- Recording an outcome when no data in the field, how to stop?
- How to download recording from messenger - Guide
- Tmobile data check - Guide
- How to send recording in messenger - Guide
- Audacity listen while recording - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 10, 2013 at 10:46 AM
Mar 10, 2013 at 10:46 AM
You question is showing that you know what to do. If you think about it, you are talking about two IF, one if columns are blank and other for spread
=IF(condtion, <when true>, <when false>)
your if statement can have seven ifs embedded
=IF(cond1, If(cond2, <true cond1 and 2>, <true cond1 and false cond2), <false cond 1)
ok so much for teaching to fish, now to part of giving fish
=IF(AND( b6 <>""; d6,<>""; c6 <>""),If((b6-c6)>d6; 1); "")
what formula is saying is
if B6, C6 AND D6 are not equal to "" then use your if logic
if any one of B6,C6 or D6 is equal to "", then just show ""
=IF(condtion, <when true>, <when false>)
your if statement can have seven ifs embedded
=IF(cond1, If(cond2, <true cond1 and 2>, <true cond1 and false cond2), <false cond 1)
ok so much for teaching to fish, now to part of giving fish
=IF(AND( b6 <>""; d6,<>""; c6 <>""),If((b6-c6)>d6; 1); "")
what formula is saying is
if B6, C6 AND D6 are not equal to "" then use your if logic
if any one of B6,C6 or D6 is equal to "", then just show ""
