If a cell is blank/empty return a value or perform a calculation

[mel_lopez]

Hi there,

I have two cells, B7 and C7, they are date formatted.

If both B7 and C7 are blank I need to return 0 (zero)

If, however, B7 has a value, but C7 is blank, I need to insert a value of .5

If both B7 and C7 have values I need to perfom the calculation "=NETWORKDAYS(B7,C7,Summary_page!$B$4:$B$11)"

I know I can use "=IF(ISBLANK" to return 0 (zero) when both B7 and C7 are empty, but from there I'm not sure what to do next.

I must admit this has me a bit flummoxed anyone have any ideas or can point me in the right direction?

Thanks very much.

Kind regards,

Mel

[oeldere]

you can try this one (untested)

=if(and(b7<>0,c7<>0),NETWORKDAYS(B7,C7,Summary_page!$B$4:$B$11),if(c7="",0.5,0))

[AlKey]

Maybe this

Please Login or Register  to view this content.

[6StringJazzer]

Please Login or Register  to view this content.

Note the condition with a "??" result. This is when B7 is blank but C7 has a value. You did not cover that case in your explanation. Replace "??" with what result you want in that case.

[mel_lopez]

Thanks very much for the quick response.

The formula works a treat!

I had to make a slight amendment - you had a typo using 5 where 0.5 was the required value.

Otherwise a much more succinct formula than what I was originally attempting to try and get working.

[mel_lopez]

Thanks very much for the quick response.

The formula works a treat!

I had to make a slight amendment - you had a typo, using 5 where 0.5 was the required value, but otherwise a much more succinct formula than what I was originally attempting to try and get working.

[oeldere]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.