if, and or type formula

[TOYKING23]

I need cell V5 to equal both following situations.
V5=P5-R5-U5, this formula I have.
But, I also want V5 to equal 0 if R5=0 or blank and or U5 = 0 or blank
The second part is what I can’t figure out how to do in conjunction with the first formula, any help is appreciated.

Thanks

 

[Joe4]

Try:

=IF(OR(R5="",R5=0,U5=0,U5=""),0,P5-R5-U5)

 

[TOYKING23]

I tried and received an inconsistent formula error

 

[Joe4]

I tried and received an inconsistent formula error

Are you perhaps using a European version of Excel?
If so, it may require that the argument separators be semi-colons instead of commas, i.e.

=IF(OR(R5="";R5=0;U5=0;U5="");0;P5-R5-U5)

 

[TOYKING23]

USA version, not sure why I receive the error.

 

[Joe4]

There is nothing special about that formula. IF and OR statement are very basic that should work in any version of Excel. They have been around pretty much since the inception of Excel.

What is your exact error message?
Is there anything special about the cells being referenced?
Are there any merged cells or errors in any of the cells being referenced?
Was the data in this cells enter manually, or copied/downloaded from another program or the internet?
Are you copying/pasting my data, or typing it manually (try copying it to ensure there are no typos)?

 

[Joe4]

Actually, in researching, that does not indicate any error with the formula itself, it is saying that it is not consistent with the formulas around it.
You may not care, and can ignore it.

See this here, especially the "Not an error?" section: https://support.office.com/en-us/ar...-formula-5dd940a1-4f87-44bd-91dd-bf45ed828f05

 

[TOYKING23]

I copied and pasted formula, no merged cells, data is entered manually. I tried pasting a screen shot, but apparently I can't do that correctly or attach the work book.

 

[Joe4]

See my last post. It doesn't appear it is any sort of error with the formula. Rather, Excel warning you that the formula does not follow the same pattern as nearby formulas.

 

[TOYKING23]

That's it, once I removed the previous formula from all cells and pasted the new one it worked. thank you so very much.