IF formula

[mikerules]

I have the following in Y10 and would like to modify it based on the content of D8

=IFERROR(+H16*Y8,"")

If D8=Yes then the above would apply

If D8 = NO or blank then the entry would be 0

[Richard Buttrey]

Hi

One way

Please Login or Register  to view this content.

I have assumed 'No' or blank are the only two other options.Otherwise

Please Login or Register  to view this content.

[Pete_UK]

Try this:

=IF(D8="yes",IFERROR(H16*Y8,""),0)

This doesn't test explicitly for No or blank (assumes those are the alternatives to Yes).

Next time consider a thread title which is a bit more descriptive of your problem.

Hope this helps.

Pete

[mikerules]

Thanks for your reply