i have 3 columns.
A b &c
A= .120kva (numeric values change)
B=100ohm fail OR 100ohm pass (numeric values change)
what Im trying to do is check to see if column B reads pass or fail
If B reads pass then multiply cell A by 1000 and show result as (numeric) WATTS
if B reads fail then show result as 0 watts ( or leave blank)
how do i get excel to ignore the KVA in cloumn A and the numeric value in column B.
Neen on this all day and cant for the life of me see how to do it
Any help is greatly received
Many thanks
Allen
Bookmarks