I am looking to have J11 multiply C11 by F11, if C4 has a number or have J11 multiply by H11, if C4 has no number.
I am looking to have J11 multiply C11 by F11, if C4 has a number or have J11 multiply by H11, if C4 has no number.
Last edited by HaloMike; 12-23-2021 at 02:33 PM.
Try this in J11:
=IF(ISNUMBER($C$4),F11,H11)*C11
Hope this helps.
Pete
This is perfect, Thank you
Glad to help, and thanks for the rep.
Merry Christmas.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks