Recording an outcome when no data in the field, how to stop?
Closed
Joshte
Posts
3
Registration date
Thursday 7 March 2013
Status
Member
Last seen
9 March 2013
-
9 Mar 2013 à 14:34
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 10 Mar 2013 à 10:46
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 10 Mar 2013 à 10:46
Related:
- Recording an outcome when no data in the field, how to stop?
- Tmobile data check - Guide
- How to copy data from one excel sheet to another - Guide
- How to send recording in messenger - Guide
- How to reinstall windows 10 without losing data - Guide
- Data transmission cables - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
10 Mar 2013 à 10:46
10 Mar 2013 à 10:46
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 ""
