How can I use a If then statement to look at two or more cells in the function before returning a value.
=if(c5="2" and d5="1",175,if(c5="1" and d5="2",225,l5/.9))
I know this isnt right need help please
How can I use a If then statement to look at two or more cells in the function before returning a value.
=if(c5="2" and d5="1",175,if(c5="1" and d5="2",225,l5/.9))
I know this isnt right need help please
=if(and(c5=2,d5=1),175,if(and(c5=1,d5=2),225,L5/.9))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks