Result only if two other cells contain data

[Detectiveclem]

Can aone assist please

I have the following formula =IF(D7-C7<0, 1+D7-C7, D7-C7)which produces the result I want in Cell E7.

However I do not want anythingshowing in E7 unless there is data in both C7 & D7. Can anyone assist mewith the correct formula to use for this?


Thank you.

 

[AlanY]

try

=if(and(isblank(C7),isblank(D7)),"",IF(D7-C7<0, 1+D7-C7, D7-C7))

 

[Special-K99]

=if(c7*d7=0,"",(c7 < d7)+(c7-d7))

 

[Detectiveclem]

Hi AlanY,

This only works properly if both Cells C7 and D7 are populated It doesn'twork if only C7 is populated.

 

[AlanY]

my bad, change the AND to OR should work

=IF(OR(ISBLANK(C7),ISBLANK(D7)),"",IF(D7-C7<0, 1+D7-C7, D7-C7))

 

[Detectiveclem]

Thank you AlanY, works perfectly now thank you.

 

[Detectiveclem]

Thank you Special-K99.

 

[AlanY]

Thank you AlanY, works perfectly now thank you.

you're welcome