I'm fairly new to excel. I'm trying to do a calculation based off if cells are populated with a value greater than or equal to 0. This is the formula I input in my 'Results' cell:
=IF(D3="","",IF(D3>=0,(B3*C3*D3)/10000,IF(E3="","",IF(E3>=0,B3*C3*E3,))))
I'm getting a result from cell D3 but not E3. Your input would be greatly appreciated.
Thanks.
I suspect that D3 may be blank in which case your formula never gets past the first IF Test.
Behind your question I'm implying that perhaps if d3 is negative you want the E3 test to take effect.
It doesn't always help to post just your formula without any explanation since by definition it's not working as you expect.
Perhaps you could explain exactly what are you trying to do since the D3 and E3 test calculations are the same and could presumably be met with an 'OR' condition in there. However explain in narrative form what you want and no doubt we can help further.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
What I'm trying to do is create a rate calculator for insurance. I'm using a dropdown list in Cell D and a dropdown list in Cell E. If the end user selects a value in either of the cells, it's supposed to Multipy the values in cell B, C and D or E and divide by 10,000. If nothing is selected from the dropdown, it will return a null. Am I way off in my explanation?
Thanks,
Ed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks