IF formula needed
Hi guys...
Please see my attached example.... I'm after an IF formula to go with a formula i've already put in and cant remember how to do it!! Hope it makes sense....
Cheers in advance!!!!!
try this:
=IF(F9="BER";0;SUM('Doc Log sheet'!E13*'Doc Log sheet'!B13))
(Replace ; with , if needed)
"Relax. What is mind? No matter. What is matter? Never mind!"
That works great, thanks alot!!!!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks