Your logical test needs to include an AND so it becomes:
=IF(AND(F6="yes",D5="" ),"",D5*0.0008 )
Another excel question. Sorry.
I have a sheet I am working on for hedgehog drug treatments and want to add an IF statement to apply before another if statement but I cant seem to get it working. Help
Example. Cell F5 checks to see if there is a weight in cell D5 if so, apply the weight/dose formula. But.... I also want it to check cell F2 to see if it contains a YES before doing the calculation or if the cell contains NO do nothing.
Doe that make sense? I hope so.
So in F5 I currently have
=IF(D5="","",D5*0.0008 ) ignore the space I had to add it on here cos of emotes
You might have to make some additions to force the case into upper text for the check etc but this will do it conditionally on Yes/No
your conditional format is for a blank cell. it's no longer blank when it has a value in.
Couldn't seem to get the conditional formatting to work any more, so I gave up.
The final version seems to work though, so thanks folks.
This makes it much easier for Miss Wrat and I to work out the jabs.